附录：GBase 8s 的 SQL 关键字

该附录列出的 GBase 8s SQL 中实现的关键字。

ISO 标准 SQL 语言有很多关键字。一些被指定为保留字，而另一些指定为非保留字。在 ISO SQL 中，保留字不能用作数据库对象的标识符，例如：表、列等。要在有效的 SQL 语句中使用保留字作为名称，需要定界标识符（定界标识符）包含在双引号（" "）之间。

相反， GBase 8s 数据库服务器实现的 SQL 方言在遵守标识符（标识符）规则的字符串意义上几乎没有保留字，但是当用作标识符时，总是产生编译错误或运行错误。如果定义与内置 SQL 函数、表达式运算符具有相同的名称的 SPL 例程，则应用程序可能会遇到受限制的功能，或者意外的结果。

请不要将此附录中的任何关键字声明为 SQL 标识符。如果这样做，如果标识符出现在关键字有效的上下文中国，则可能出现错误或语义模糊。此外，您的代码将更难以阅读和维护。 GBase 8s 为内置例程和数据库对象保留前缀 ifx_ 和 sys 。不要在数据库结构中使用 C 或 C++ （或者嵌入式模式中使用的任何其它编程语言）。以下按字母顺序排列的列表中的符号 IFX_* 和 SYS*（其中 * 是任意字符串的通配符）。这些表示在数据库对象的用户定义标识符中应避免使用这些前缀。（本附录中未列出以这些前缀作为开头的 SQL 关键字，其目标是帮助 GBase 8s 用户避免数据库服务器内部使用的名称。）

如果接收到到与导致错误的 SQL 语句无关的错误消息，请查看本附录，了解是否将关键字用作标识符。

要避免使用关键字作为标识符，您可以使用所有者名称限定标识符或修改标识符。例如，并非将数据库对象命名为 CURRENT，而是将它命名为 o_current 或 juanita.current。有关使用关键字作为标识符存在的潜在问题的讨论，以及指定关键字的附加解决方法，请参阅使用关键字作为标识符。有关在 SQL 应用程序中使用关键字作为标识符的更多信息，请参阅 GBase 8s SQL 教程指南。

AAO
ABS
ABSOLUTE
ACCESS
ACCESS_METHOD
ACCOUNT
ACOS
ACOSH
ACTIVE
ADD
ADDRESS
ADD_MONTHS
ADMIN
AFTER
AGGREGATE
ALIGNMENT
ALL
ALL_ROWS
ALLOCATE
ALTER
AND
ANSI
ANY
APPEND
AQT
ARRAY
AS
ASC
ASCII
ASIN
ASINH
ASYNC
AT
ATAN
ATAN2
ATANH
ATTACH
ATTRIBUTES
AUDIT
AUTHENTICATION
AUTHID
AUTHORIZATION
AUTHORIZED
AUTO
AUTOFREE
AUTOLOCATE
AUTO_READAHEAD
AUTO_REPREPARE
AUTO_STAT_MODE
AVG
AVOID_EXECUTE
AVOID_FACT
AVOID_FULL
AVOID_HASH
AVOID_INDEX
AVOID_INDEX_SJ
AVOID_MULTI_INDEX
AVOID_NL
AVOID_STAR_JOIN

BARGROUP
BASED
BEFORE
BEGIN
BETWEEN
BIGINT
BIGSERIAL
BINARY
BITAND
BITANDNOT
BITNOT
BITOR
BITXOR
BLOB
BLOBDIR
BOOLEAN
BOTH
BOUND_IMPL_PDQ
BUCKETS
BUFFERED
BUILTIN
BY
BYTE

CACHE
CALL
CANNOTHASH
CARDINALITY
CASCADE
CASE
CAST
CEIL
CHAR
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
CHARINDEX
CHECK
CHR
CLASS
CLASS_ORIGIN
CLIENT
CLOB
CLOBDIR
CLOSE
CLUSTER
CLUSTER_TXN_SCOPE
COBOL
CODESET
COLLATION
COLLECTION
COLUMN
COLUMNS
COMMIT
COMMITTED
COMMUTATOR
COMPONENT
COMPONENTS
COMPRESSED
CONCAT
CONCURRENT
CONNECT
CONNECTION
CONNECTION_NAME
CONNECT_BY_ISCYCLE
CONNECT_BY_ISLEAF
CONNECT_BY_ROOT
CONST
CONSTRAINT
CONSTRAINTS
CONSTRUCTOR
CONTEXT
CONTINUE
COPY
COS
COSH
COSTFUNC
COUNT
CRCOLS
CREATE
CROSS
CUME_DIST
CURRENT
CURRENT_ROLE
CURRENT_USER
CURRVAL
CURSOR
CYCLE

DATA
DATABASE
DATAFILES
DATASKIP
DATE
DATETIME
DAY
DBA
DBDATE
DBINFO
DBPASSWORD
DBSA
DBSERVERNAME
DBSECADM
DBSSO
DEALLOCATE
DEBUG
DEBUGMODE
DEBUG_ENV
DEC
DECIMAL
DECLARE
DECODE
DECRYPT_BINARY
DECRYPT_CHAR
DEC_T
DEFAULT
DEFAULTESCCHAR
DEFAULT_ROLE
DEFAULT_USER
DEFERRED
DEFERRED_PREPARE
DEFINE
DEGREES
DELAY
DELETE
DELETING
DELIMITED
DELIMITER
DELUXE
DENSERANK
DENSE_RANK
DESC
DESCRIBE
DESCRIPTOR
DETACH
DIAGNOSTICS
DIRECTIVES
DIRTY
DISABLE
DISABLED
DISCARD
DISCONNECT
DISK
DISTINCT
DISTRIBUTEBINARY
DISTRIBUTESREFERENCES
DISTRIBUTIONS
DOCUMENT
DOMAIN
DONOTDISTRIBUTE
DORMANT
DOUBLE
DROP
DTIME_T

EACH
ELIF
ELSE
ENABLE
ENABLED
ENCRYPT_AES
ENCRYPT_TDES
ENCRYPTION
END
ENUM
ENVIRONMENT
ERKEY
ERROR
ESCAPE
EXCEPT
EXCEPTION
EXCLUSIVE
EXEC
EXECUTE
EXECUTEANYWHERE
EXEMPTION
EXISTS
EXIT
EXP
EXPLAIN
EXPLICIT
EXPRESS
EXPRESSION
EXTDIRECTIVES
EXTEND
EXTENT
EXTERNAL
EXTYPEID
EXTYPELENGTH
EXTYPENAME
EXTYPEOWNERLENGTH
EXTYPEOWNERNAME

FACT
FALSE
FAR
FETCH
FILE
FILETOBLOB
FILETOCLOB
FILLFACTOR
FILTERING
FINAL
FIRST
FIRST_ROWS
FIRST_VALUE
FIXCHAR
FIXED
FLOAT
FLOOR
FLUSH
FOLLOWING
FOR
FORCE
FORCED
FORCE_DDL_EXEC
FOREACH
FOREIGN
FORMAT
FORMAT_UNITS
FORTRAN
FOUND
FRACTION
FRAGMENT
FRAGMENTS
FREE
FROM
FULL
FUNCTION

G
GB
GENERAL
GET
GETHINT
GIB
GLOBAL
GO
GOTO
GRANT
GREATERTHAN
GREATERTHANOREQUAL
GRID
GRID_NODE_SKIP
GROUP

HANDLESNULLS
HASH
HAVING
HDR
HDR_TXN_SCOPE
HEX
HIGH
HINT
HOLD
HOME
HOUR

IDATA
IDSLBACREADARRAY
IDSLBACREADSET
IDSLBACREADTREE
IDSLBACRULES
IDSLBACWRITEARRAY
IDSLBACWRITESET
IDSLBACWRITETREE
IDSSECURITYLABEL
IF
IFX_*
ILENGTH
IMMEDIATE
IMPLICIT
IMPLICIT_PDQ
IN
INACTIVE
INCREMENT
INDEX
INDEXES
INDEX_ALL
INDEX_SJ
INDICATOR
GBASEDBT
GBASEDBTCONRETRY
GBASEDBTCONTIME
INIT
INITCAP
INLINE
INNER
INOUT
INSENSITIVE
INSERT
INSERTING
INSTEAD
INSTR
INT
INT8
INTEG
INTEGER
INTERNAL
INTERNALLENGTH
INTERSECT
INTERVAL
INTO
INTRVL_T
IS
ISCANONICAL
ISOLATION
ITEM
ITERATOR
ITYPE

J - K

JAVA
JOIN
K
KB
KEEP
KEY
KIB

LABEL
LABELEQ
LABELGE
LABELGLB
LABELGT
LABELLE
LABELLT
LABELLUB
LABELTOSTRING
LAG
LANGUAGE
LAST
LAST_DAY
LAST_VALUE
LATERAL
LEAD
LEADING
LEFT
LEN
LENGTH
LESSTHAN
LESSTHANOREQUAL
LET
LEVEL
LIKE
LIMIT
LIST
LISTING
LOAD
LOCAL
LOCATOR
LOCK
LOCKS
LOCOPY
LOC_T
LOG
LOG10
LOGN
LONG
LOOP
LOTOFILE
LOW
LOWER
LPAD
LTRIM
LVARCHAR

M
MATCHED
MATCHES
MAX
MAXERRORS
MAXLEN
MAXVALUE
MB
MDY
MEDIAN
MEDIUM
MEMORY
MEMORY_RESIDENT
MERGE
MESSAGE_LENGTH
MESSAGE_TEXT
MIB
MIDDLE
MIN
MINUS
MINUTE
MINVALUE
MOD
MODE
MODERATE
MODIFY
MODULE
MONEY
MONTH
MONTHS_BETWEEN
MORE
MULTISET
MULTI_INDEX

NAME
NCHAR
NEAR_SYNC
NEGATOR
NEW
NEXT
NEXT_DAY
NEXTVAL
NLSCASE
NO
NOCACHE
NOCYCLE
NOMAXVALUE
NOMIGRATE
NOMINVALUE
NONE
NON_RESIDENT
NON_DIM
NOORDER
NORMAL
NOT
NOTEMPLATEARG
NOTEQUAL|
NOVALIDATE
NTILE
NULL
NULLABLE
NULLIF
NULLS
NUMBER
NUMERIC
NUMROWS
NUMTODSINTERVAL
NUMTOYMINTERVAL
NVARCHAR
NVL

OCTET_LENGTH
OF
OFF
OLD
ON
ONLINE
ONLY
OPAQUE
OPCLASS
OPEN
OPTCOMPIND
OPTIMIZATION
OPTION
OR
ORDER
ORDERED
OUT
OUTER
OUTPUT
OVER
OVERRIDE

PAGE
PARALLELIZABLE
PARAMETER
PARTITION
PASCAL
PASSEDBYVALUE
PASSWORD
PDQPRIORITY
PERCALL_COST
PERCENT_RANK
PIPE
PLI
PLOAD
POLICY
POW
POWER®
PRECEDING
PRECISION
PREPARE
PREVIOUS
PRIMARY
PRIOR
PRIVATE
PRIVILEGES
PROCEDURE
PROPERTIES
PUBLIC
PUT

QUARTER

RADIANS
RAISE
RANGE
RANK
RATIOTOREPORT
RATIO_TO_REPORT
RAW
READ
REAL
RECORDEND
REFERENCES
REFERENCING
REGISTER
REJECTFILE
RELATIVE
RELEASE
REMAINDER
RENAME
REOPTIMIZATION
REPEATABLE
REPLACE
REPLICATION
RESOLUTION
RESOURCE
RESTART
RESTRICT
RESUME
RETAIN®
RETAINUPDATELOCKS
RETURN
RETURNED_SQLSTATE
RETURNING
RETURNS
REUSE
REVERSE
REVOKE
REF
RIGHT
ROBIN
ROLE
ROLLBACK
ROLLFORWARD
ROLLING
ROOT
ROUND
ROUTINE
ROW
ROWID
ROWIDS
ROWNUMBER
ROWS
ROW_COUNT
ROW_NUMBER
RPAD
RTRIM
RULE

SAMEAS
SAMPLES
SAMPLING
SAVE
SAVEPOINT
SCHEMA
SCALE
SCROLL
SECLABEL_BY_COMP
SECLABEL_BY_NAME
SECLABEL_TO_CHAR
SECOND
SECONDARY
SECURED
SECURITY
SECTION
SELCONST
SELECT
SELECTING
SELECT_GRID
SELECT_GRID_ALL
SELFUNC
SELFUNCARGS
SENSITIVE
SEQUENCE
SERIAL
SERIAL8
SERIALIZABLE
SERVER
SERVER_NAME
SERVERUUID
SESSION
SET
SETSESSIONAUTH
SHARE
SHORT
SIBLINGS
SIGNED
SIN
SITENAME
SIZE
SKIP
SMALLFLOAT
SMALLINT
SOME
SOURCEID
SOURCETYPE
SPACE
SPECIFIC
SQL
SQLCODE
SQLCONTEXT
SQLERROR
SQLSTATE
SQLWARNING
SQRT
STABILITY
STACK
STANDARD
START
STAR_JOIN
STATCHANGE
STATEMENT
STATIC
STATISTICS
STATLEVEL
STATUS
STDDEV
STEP
STOP
STORAGE
STORE
STRATEGIES
STRING
STRINGTOLABEL
STRUCT
STYLE
SUBCLASS_ORIGIN
SUBSTR
SUBSTRING
SUBSTRING_INDEX
SUM
SUPPORT
SYNC
SYNONYM
SYS*

T
TABLE
TABLES
TAN
TASK
TB
TEMP
TEMPLATE
TEST
TEXT
THEN
TIB
TIME
TO
TODAY
TO_CHAR
TO_DATE
TO_DSINTERVAL
TO_NUMBER
TO_YMINTERVAL
TRACE
TRAILING
TRANSACTION
TRANSITION
TREE
TRIGGER
TRIGGERS
TRIM
TRUE
TRUNC
TRUNCATE
TRUSTED
TYPE
TYPEDEF
TYPEID
TYPENAME
TYPEOF

UID
UNBOUNDED
UNCOMMITTED
UNDER
UNION
UNIQUE
UNITS
UNKNOWN
UNLOAD
UNLOCK
UNSIGNED
UPDATE
UPDATING
UPON
UPPER
USAGE
USE
USELASTCOMMITTED
USER
USE_HASH
USE_NL
USING
USTLOW_SAMPLE

VALUE
VALUES
VAR
VARCHAR
VARIABLE
VARIANCE
VARIANT
VARYING
VERCOLS
VIEW
VIOLATIONS
VOID
VOLATILE

W - Z

WAIT
WARNING
WEEKDAY
WHEN
WHENEVER
WHERE
WHILE
WITH
WITHOUT
WORK
WRITE
WRITEDOWN
WRITEUP
XADATASOURCE
XID
XLOAD
XUNLOAD
YEAR